package com.hxkcloud.patient.db;

/**
 * Created by ray_lei on 2016/7/5.
 */
public class YjhTable {


    /*
     * 用户登录信息数据表
     */
    //表名
    public static final String YJH_USERLOGIN = "yjh_userlogin";
    //删除数据表
    public final static String YJH_USERLOGIN_EXISTS = "drop table if exists " + YJH_USERLOGIN;
    // 创建用户登录信息数据表
    public final static String YJH_USERLOGIN_CREATE = "create table if not exists "
            + YJH_USERLOGIN
            + "("
            + "_ID    			INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"//ID
            + "TOKEN      			TEXT NOT NULL,"//Token
            + "USERID     			TEXT NOT NULL,"//UserId
            + "USERSTYLE        		TEXT,"//UserStyle
            + "NAME        		   TEXT,"//Name
            + "AGE                  TEXT,"//Age
            + "SEX        		   TEXT,"//Sex
            + "HEIGHT               TEXT,"//Height
            + "WEIGHT               TEXT,"//Weight
            + "HEADIMAGE            TEXT,"//HeadImg
            + "ADDRESS              TEXT,"//Address
            + "DEPARTMENTID         TEXT,"//DepartmentId
            + "TITLE                TEXT,"//Title
            + "WORKINGYEARS         TEXT,"//WorkingYears
            + "SCHOOL               TEXT,"//School
            + "WORKUNIT             TEXT,"//WorkUnit
            + "SPECIALTY            TEXT,"//Specialty
            + "SECDATA              TEXT" //Secdata
            + ");";




    /*
     * 基础数据-地区数据表
     *
     */
    // 表名
    public static final String YJH_BASIC_DISTRICT = "yjh_basic_district";
    //删除数据表
    public final static String YJH_BASIC_DISTRICT_EXISTS = "drop table if exists " + YJH_BASIC_DISTRICT;
    // 创建医院数据表
    public final static String YJH_BASIC_DISTRICT_CREATE = "create table if not exists "
            + YJH_BASIC_DISTRICT
            + "("
            + "_ID    				INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,"//序列
            + "Id              		TEXT,"//地区ID
            + "NAME      			TEXT,"//地区名称
            + "PARENTID     		TEXT,"//上级地区ID
            + "LEVEL        		INTEGER,"//地区级别
            + "FULLNAME        		TEXT,"//地区全名
            + "FULLIDPATH           TEXT,"//地区完整ID
            + "SECDATA              TEXT"//
            + ");";






}
